﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using ZhiAo.Entities;
using ZhiAo.WebLib.Data;

/// <summary>
///GlobalCache 的摘要说明
/// </summary>
public static class GlobalCache
{
    public static void LoadStations()
    {
        if (HttpContext.Current.Cache["stations"] != null)
        {
            HttpContext.Current.Cache.Remove("stations");                    
        }
        
        string strSql = "SELECT Yr_stcd,STCD,Stnm,Lgtd,Lttd FROM SQ_STBPRP_B WHERE Lgtd <> '' AND Lttd <> '' AND Lgtd is not null and lttd is not null";
        
        DataTable dt = DBHelper.GetDataTable(strSql);
        HttpContext.Current.Cache["stations"] = dt;
    }
}
